Optimization of Transaction Database Design with MySQL and MongoDB
نویسندگان
چکیده
Database is one of the most important parts in running an application. Databases can be used to store data. However, application, selection appropriate database needs considered, so that resulting information accordance with user needs. In developing applications, more people use RDBMS design which has a very structured nature, but technological developments have introduced NoSQL as development method. this research, MySQL and MongoDB databases will tested transaction processing. The tests carried out include comparisons designs, defining table structures, time insert, update, delete, search processes. test results show simpler description structure than MySQL. faster difference insert process there 0.005625 sec, update 0.001688 delete 0.00075 sec 0.006875 sec.
منابع مشابه
Flash Game with Mysql Database Development
This research is intended to develop a model of multimedia application, particularly a puzzle game for Interactive Multimedia Course. This model should encourage students to integrate all information resources to develop a multimedia application particularly puzzle game. The puzzle game application generates input and processed data as a server-side with Adobe Flash. Flash is a powerful and dyn...
متن کاملA hybrid approach for database intrusion detection at transaction and inter-transaction levels
Nowadays, information plays an important role in organizations. Sensitive information is often stored in databases. Traditional mechanisms such as encryption, access control, and authentication cannot provide a high level of confidence. Therefore, the existence of Intrusion Detection Systems in databases is necessary. In this paper, we propose an intrusion detection system for detecting attacks...
متن کاملApply Uncertainty in Document-Oriented Database (MongoDB) Using F-XML
As moving to big data world where data is increasing in unstructured way with high velocity, there is a need of data-store to store this bundle amount of data. Traditionally, relational databases are used which are now not compatible to handle this large amount of data, so it is needed to move on to non-relational data-stores. In the current study, we have proposed an extension of the Mongo...
متن کاملApply Uncertainty in Document-Oriented Database (MongoDB) Using F-XML
As moving to big data world where data is increasing in unstructured way with high velocity, there is a need of data-store to store this bundle amount of data. Traditionally, relational databases are used which are now not compatible to handle this large amount of data, so it is needed to move on to non-relational data-stores. In the current study, we have proposed an extension of the Mongo...
متن کاملA Lump-sum Update Method as Transaction in MongoDB
Along with the progress of the cloud computing, it became necessary to deal with various and large quantity data in the distributed database environments. So, the various NoSQL databases have been proposed and put to practical use. However, as for the NoSQL databases, since it supports the distributed environment, the integrity of the database update is basically guaranteed only by the object u...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
ژورنال
عنوان ژورنال: Sinkron : jurnal dan penelitian teknik informatika
سال: 2022
ISSN: ['2541-2019', '2541-044X']
DOI: https://doi.org/10.33395/sinkron.v7i3.11528